﻿CREATE TABLE t_city (
    Id INT PRIMARY KEY IDENTITY,
    Code VARCHAR(4),
    Name VARCHAR(50),
    English VARCHAR(100),
    PostCode VARCHAR(10),
    AreaCode VARCHAR(10)
)